Copy database backups and archives

The database backups from the old system need to be copied to the SBS Upgrade Package. The following databases from the old system must be backed up:

  • ION_Data (contains the historical data and event logs)
  • ION_Network (contains the configuration information)
  • ApplicationModules (contains the Web application related information)

Note: Do not copy a backup of the System Log database; it contains information relevant to the old IONESPMPME system. The new PME system has its own System Event log.

Distributed System Note: The databases and archives are located on the Database Server.

To back up the system databases and database archives:

  1. Open SQL Server Management Studio and connect to the IONESPMPME database instance.

    2. Note: You can find the location of the database files by viewing the Properties of the database in SQL Server Management Studio.

     

  1. Right-click the ION_Data database and then click Tasks > Back Up.

  2. Name the backup file ION_Data and back it up to the ...\SBS Upgrade Package\Database_Backups folder.

Note: You can expect this backup process to take about 15 minutes for a 10 GB database.

  1. Repeat this process for the ION_Network and ApplicationModules databases. Use ION_Network and ApplicationModules as the label names for the backup files.

Repeat this process to backup the database archives from the old system, using the name of the archive as the name for the backup. Copy them to the ...\SBS Upgrade Package\Database_Archives folder.